//////////////////////////////////////////////////////////////////////////

#ifndef _QUERIES_H_
#define _QUERIES_H_

//////////////////////////////////////////////////////////////////////////


/** Insert patient query */
const char QUERY_INSERT_PATIENT[] = "insert into 'PATIENTS' values (?, ?, ?, ?, ?, ?, ?, ?)";


/** Select patients by history query */
const char QUERY_SELECT_PATIENT_BY_HISTORY[] = "select * from patients where history == ?";


/** Select patients by surname query */
const char QUERY_SELECT_PATIENT_BY_SURNAME[] = "select * from patients where surname == ?";


/** Save research query */
const char QUERY_SAVE_RESEARCH[] = "insert into 'RESEARCH' values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";


/** Update patient query */
const char QUERY_UPADTE_PATIENT[] = "update patients set surname = ?, name = ?, secondname = ?, birthday = ?, sex = ?, diagnosis = ?, notes = ? where history = ?";


/** Delete patient by history query */
const char QUERY_DELETE_PATIENT_BY_HISTORY[] = "delete from patients where history == ?";


/** Select researches by history query */
const char QUERY_SELECT_RESEARCHES_BY_HISTORY[] = "select * from research where history = ?";


//////////////////////////////////////////////////////////////////////////

#endif

//////////////////////////////////////////////////////////////////////////
